Cloud Native Applications with Ballerina by Dhanushka Madushan

Author:Dhanushka Madushan [Dhanushka Madushan]
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2021-10-29T00:00:00+00:00

Items in inventories are kept in the InventoryItems table. That table is generated by the following SQL query:CREATE TABLE 'InventoryItems' (

'InventoryItemId' varchar(50) NOT NULL,

'InventoryId' varchar(50) DEFAULT NULL,

'ProductId' varchar(50) DEFAULT NULL,

'Quantity' int DEFAULT NULL,

PRIMARY KEY ('InventoryItemId'),

KEY 'InventoryId_idx' ('InventoryId'),

KEY 'ProductId_idx' ('ProductId')

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Pending orders that have not proceeded to payment are stored inside the PendingOrderItems table. This holds InventoryItemId along with the quantity:CREATE TABLE 'PendingOrderItems' (

'PendingOrderItemId' varchar(50) NOT NULL,

'OrderId' varchar(50) DEFAULT NULL,

'InventoryItemId' varchar(50) DEFAULT NULL,

'Quantity' int DEFAULT NULL,

PRIMARY KEY ('PendingOrderItemId')

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.